How to append multiple columns into two.

Hello,
I have an Excel report that's coming out of one of our systems that has the following columns:

Folder / Name / Company / Counterparty / Effective Date / Termination Date / Fee Type 1 / Fee Amount 1 / Fee Type 2 / Fee Amount 2 / Fee Type 3 / Fee Amount 3 ..... Fee Type 23 / Fee Amount 23

I don't know how to create a macro that will take all the Fee Type and Fee Amount columns and append all of them into two columns instead of the 46 I currently have.
I want the first columns to repeat themselves and then append the Fee columns in two.

Thank you for your support!
Marianne

Welcome to the forum. It would help us to help you if you upload an example file. Follow instructions in yellow section above.

Sorry, forgot to add it! Please see attached!
Thank you!

Definitely go for power query in this case

That's not the result I was looking for - I want the Fee Types to be one column and Fee Amounts to be another column, where Fee Type 1 and Fee Amount 1 are side by side.

Here is an option for you. If the results are not what you expected please add an example.

Please Login or Register  to view this content.

That worked perfectly, thank you!

Just for the fun of it, here my completed option.

Please Login or Register  to view this content.