+ Reply to Thread
Results 1 to 6 of 6

Display Header at next Column

  1. #1
    Registered User
    Join Date
    03-06-2009
    Location
    Malaysia
    MS-Off Ver
    Excel 2010 and 2013
    Posts
    47

    Display Header at next Column

    Dear Friends,

    I received extracted data where the arrangements seems difficult to get the end result. The Headers are located on top and I'm supposed to do some sort of filtering so that the Header will appear on the left side. From what i know, to filter out such result, the values have to somehow be side by side but now the Headers are on top.

    I have attached a file to display the intended end result. Since the data is sensitive, i have to substitute them with football data. I've tried using basic filtering, where i can extract out those under the category England by creating a working cell column beside denoting "England". Only thing is how to display the Team names beside the Players names?

    Thanks for your help in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,904

    Re: Display Header at next Column

    Deleted post.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,667

    Re: Display Header at next Column

    Your source data does not have the Team Data which is shown in the expected result.

    Also please explain why you have omitted rows 14 to 16 in the expected result?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,904

    Re: Display Header at next Column

    There is definitely problem with getting the teams out but other then that is fine.

    Please see attached file
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-06-2009
    Location
    Malaysia
    MS-Off Ver
    Excel 2010 and 2013
    Posts
    47

    Re: Display Header at next Column

    Hi Sixthsense,

    I'm doing a simulation to show that the end result wants to filter out values from row 14-16 while it also wants the Team to be displayed at the side.

  6. #6
    Registered User
    Join Date
    03-06-2009
    Location
    Malaysia
    MS-Off Ver
    Excel 2010 and 2013
    Posts
    47

    Re: Display Header at next Column

    Hi AlKey.

    Thank you very much for your help. The formula looks quite difficult to understand but it does help to solve my case.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 07-25-2014, 05:08 PM
  2. Replies: 1
    Last Post: 07-22-2014, 08:27 PM
  3. Simple: Column Header Display cutting off letters.
    By ScottDufour in forum Excel General
    Replies: 1
    Last Post: 12-04-2012, 02:24 PM
  4. search table display column header for n occurences
    By martin_mcnamara in forum Excel General
    Replies: 4
    Last Post: 01-28-2011, 10:00 AM
  5. Search Table, Display Column Header
    By mattalisch in forum Excel General
    Replies: 5
    Last Post: 01-27-2011, 05:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1