We help IT Professionals succeed at work.

Transpose list in excel

gregfthompson
on
I have a list in a column. Each item heading has about 10 rows of info under each heading.  The headings are in bold.

I would like the list transposed so each row currently under an item heading is in a separate column, in the same row as the item heading. 3550-ee-Bendigo-list.zip
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Hi, gregfthompson.

Unfortunately, the data isn't consistently laid out (e.g. Eaglehawk Senior Citizens Club has more than 20 entries). So I've simply taken the data under each organisation and put it opposite the organisation's name.

I highlighted and filtered the data on the organisation name so that you can see at a glance what's happening.

I'll be heading off shortly, but I'll be back within 6 hours.

Regards,
Brian.
3550-ee-Bendigo-list---V2.xlsx

Author

Commented:
Thanks heaps!!!
CERTIFIED EXPERT

Commented:
Happy to help, gregfthompson!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.