Forum Discussion
Bojkins
7 years agoFrequent Visitor
How to create a column from single cell
Hello, I need to create a column from a single cell. I have multiple single cells in table and need to convert them in to columns. Data from this single cell needs to populate all cells in new c...
Bojkins
7 years agoFrequent Visitor
Hi Tom,
Here is link : https://www.dropbox.com/s/35fn5cit43ncgmj/Sample%20data.xlsx?dl=0
Best regards,
Bojan
v-jiascu-msft
7 years agoMicrosoft Employee
Hi Bojan,
I'm afraid we can't format that table in one go. Can you provide more details, please?
1. There could be more tables like that. How do they organize?
2. Which cells are fixed?
3. Could there be any changes in position or format of these cells?
You could try VBA or Python to format it.
Best Regards,