Hello,
I have a question about converting data in multiple columns and rows into a single row for each cell. I'm wondering if anyone knows of a macro or Excel formula that could accomplish this. I'll try to provide an example below.
As Is:
Column 1 Column 2 Column 3
Row 1: Test1 Test2
Row 2...