Tracy Johnson
asked on
Excel 2016 Macro Needed: Convert Multiple Columns into Multiple Rows
I have a spreadsheet (or many). I can move it into a template that is created. I am looking for an easy-to-use macro that is run by using a form or control button of some kind that will help transform date from many rows of multiple columns of data into multiple rows of data as show in the examples below. I am using Microsoft Excel 2016.
Here is what the multiple rows of data in columns which needs to change (BEFORE) with nearly 100 lines it looks like this (different data though) which needs to look like below (AFTER) after the macro is run.
I have attached a file that was previously created by help in this group. The macro is not working. I need to make sure that the file which can remain a template (it has data for testing/validation) that additional fields can be added in Row 1 as necessary.
BEFORE EXAMPLE:
1096 HRC2-CT-S HRC2-OA-S AFS-10U CSH-USR UVSG-42 FPKDB-S
AFTER EXAMPLE:
1096 HRC2-CT-S
1096 HRC2-OA-S
1096 AFS-10U
1096 CSH-USR
1096 UVSG-43
1096 FPKDB-S
1097 etc
1097 etc
BOMLINEStemplate.xlsm
Here is what the multiple rows of data in columns which needs to change (BEFORE) with nearly 100 lines it looks like this (different data though) which needs to look like below (AFTER) after the macro is run.
I have attached a file that was previously created by help in this group. The macro is not working. I need to make sure that the file which can remain a template (it has data for testing/validation) that additional fields can be added in Row 1 as necessary.
BEFORE EXAMPLE:
1096 HRC2-CT-S HRC2-OA-S AFS-10U CSH-USR UVSG-42 FPKDB-S
AFTER EXAMPLE:
1096 HRC2-CT-S
1096 HRC2-OA-S
1096 AFS-10U
1096 CSH-USR
1096 UVSG-43
1096 FPKDB-S
1097 etc
1097 etc
BOMLINEStemplate.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Question answered.
ASKER