Combining Multiple Columns/Fields into One Field

Hello, I need to manipulate some data before I import it into a database.

The data isn't uniform across data sets, so I have to reorganize it before I may proceed.

in short: I have a few hundred fields/columns.

ID: Name: Test1Method: Test1Class: Test2Method: Test2Class: Test3Method... and so on..

instead of having multiple fields/columns for Test1Method, Test1Class, etc. I want to condense these into 1 column so the format looks similar to the following:

ID: Name: TestMethod: Test Class:
1: Bob: Combined: Second:
1: Bob: Separate: First:
1: Bob: Separate: Second:

instead of how it is now:

ID: Name: Test1M: Test1C: Test2M: Test2C:
1: Bob: Combined: Second: Separate: First:

Any instruction and or Direction would be much appreciated.

Thanks in advance,

Jamie

Welcome to the forum!

It is unclear what you need. Attach a sample xls to help us help you. In sheet2, show what you want it sheet1 to look like.