Forum Discussion

Bojkins's avatar
Bojkins
Frequent Visitor
7 years ago

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...
Need Help
Bojkins's avatar
Bojkins
Frequent Visitor
7 years ago

Hi,

 

Please find attached pictures.

 

Idea is to create new columns from one cell, not using fill down or fill up or deleting rows.

 

First picture is actual state and second is desired. 

 

Best regards,

 

Bojan

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey, 

 

as there are single cells distributed across the excel sheet, this becomes very cumbersome. Please provide an Excel workbook with sample data, upload the workbook to onedrive or dropbox and share the link.

 

Regards,

Tom

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      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,