Duplicate row headers, different data – how to combine it all into unique row headers

Hello,
This is my 1st time posting here. So, if I made a faux pas, apologies in advance. What I would like to know if there’s a way to combine rows of data into a unique row based upon the row headers in column A? I do NOT want to merge data into 1 cell. I do NOT want to consolidate with sums totals. I just want to know if there’s a way (formula or VBA or other) where I can combine row data into one row based on duplicate row headers or row titles. Here’s an example below of "Before & After". The Letters denote column letters in Excel – I’ve added them to show that row lengths would need to increase based on the data. Also, the combine data doesn’t have to be alpha-numeric order, but nice if possible. And yes, those are Portuguese words, but it’s based on an actual file dump I’ve received.


Original data file - Before
A B C D F G H I
Jan2015 acidente adorável animal
Jan2015 automóvel bagagem catedral central
Feb2015 ciclista condutor conversível
Feb2015 crime cruel elefante famoso
Mar2015 fisico futebol hospital relógio difícil
Mar2015 hotel humor importante
Apr2015 inevitável informação inventar local
Apr2015 motor natural plano
Apr2015 popular potente presidente
Apr2015 sinistro telefone
May2015 ator criatura música idéia
Jun2015 rádio conversível futebol
Jun2015 favor
Jul2015 respeitável Beleza
Aug2015 Falou táxi Valeu Rolar Joia
Aug2015 carne de boi Pão-duro segundo semana água


The Ideal - After
A B C D F G H I J K L M N
Jan2015 acidente bagagem adorável animal automóvel catedral central
Feb2015 ciclista condutor conversível crime cruel elefante famoso
Mar2015 hotel fisico futebol hospital humor importante relógio difícil
Apr2015 inevitável informação inventar local motor natural popular plano potente presidente sinistro telefone
May2015 ator criatura música idéia
Jun2015 rádio conversível futebol favor
Jul2015 respeitável Beleza
Aug2015 Falou táxi Valeu Rolar Pão-duro carne de boi Joia água

Thanks nankw83. This works. I did try attaching the file with the attach icon, but I keep getting a blank field. BTW, could be VBA be used if there is duplicate column headers - if rows are sub for columns and vice versa within the code?

Thanks Ali, once I used that VBA code fromnankw83, I then was able to use Power Query to make other changes. And I did try to attach the file with the attch icon, but I kept getting a blank field

Originally Posted by fikkie2002

BTW, could be VBA be used if there is duplicate column headers - if rows are sub for columns and vice versa within the code?

I would love to help but I am really not be able to visualize this. Please try again to attach a sample file following the instructions at the top of the page as suggested by Ali

File is attached.

nankw83, I've attached the file in a separate post. Let me know if you have any questions. Thanks.

Thanks Ali. I was able to attach the file

Thanks nankw83. This works perfectly.