Hi,

I have an exported file from Access that results in the same table being pasted adjacently to each other in one worksheet.

Example:
Item/Description/Qty/Text | Item/Description/Qty/Text | Item/Description/Qty/Text... etc.

There can be variable number of rows as well as variable times that this table has been pasted in this manner.

How can I manipulate the data so that I can merge all the columns with a similar header into one, so that I end up with just one table with the columns "Item/Description/Qty/Text", preferrably on another sheet? An additional complication is that within each table, the row has data that also needs to be kept together.

Example:
Item/Description/Qty/Text | Item/Description/Qty/Text
A1/B1/C1/D1 | E1/F1/G1/H1

needs to become:

Item/Description/Qty/Text
A1/B1/C1/D1
E1/F1/G1/H1

Any help would be appreciated! Thanks in advance.