Results 1 to 7 of 7

How to transpose data so column A is grouped and works as a header for column b

Threaded View

  1. 07-07-2021, 07:58 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How to transpose data so column A is grouped and works as a header for column b

    and this in E2 to return the names:

    =TRANSPOSE(UNIQUE(A2:A39,FALSE))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transpose multirows from two column into single row with one header
    By qiyusi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2015, 09:14 PM
  2. [SOLVED] Excel 2013 - Header Info in Column A - Transpose Question
    By alyzar in forum Excel General
    Replies: 4
    Last Post: 04-07-2015, 02:19 PM
  3. VBA code to convert multiple rows as column header grouped by unique key
    By Shreyas11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2014, 09:03 PM
  4. A Formula to get the column header grouped only if it has values in the rows.
    By Johin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2014, 10:05 AM
  5. [SOLVED] Select Header Row and Transpose to a Column in a New Worksheet
    By Kespin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 06:16 PM
  6. Match cells in column, then transpose matching row data from column b, c etc on many tabs
    By arcadian13 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-22-2012, 12:03 PM
  7. Transpose multiple rows to one column keping the row header.
    By cinciphantom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2011, 06:42 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1