Hello,
I have a requirement where i will have records with a key and values in multiple columns. I have the count of the values. I need macro help to copy the values and create multiple rows based on the number of columns. If there are 5 values in 5 columns for a key, i need to have 5 rows for that key value. I need to repeat this until all the records are copied in the source excel sheet.
I have created sample records. Sheet 1 has my input records and Sheet 2 has the expected view.
Need your support and help.
I have a requirement where i will have records with a key and values in multiple columns. I have the count of the values. I need macro help to copy the values and create multiple rows based on the number of columns. If there are 5 values in 5 columns for a key, i need to have 5 rows for that key value. I need to repeat this until all the records are copied in the source excel sheet.
I have created sample records. Sheet 1 has my input records and Sheet 2 has the expected view.
Need your support and help.