Forum Discussion
sashakorniakUK
Dec 03, 2020Copper Contributor
Excel formula function or macro? Data Migration for Horizontal Columns to Vertical Columns
Excel formula function or macro? Data Migration for Horizontal Columns to Vertical Columns This must be a common problem? I have old database exported to csv. The Old columns are; First...
adversi
Dec 04, 2020Iron Contributor
VBA or Power Query would probably be the best approach. Can you share your workbook to further test the dataset?
sashakorniakUK
Dec 04, 2020Copper Contributor
`Hey there,
Trust you are well and happy?
Thank you for helping with this. I have attached the example workbook.
🙂
- sashakorniakUKDec 04, 2020Copper Contributor
sashakorniakUK adversi Here a Gif video to help