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
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Bojan,

 

The cells are in columns. So your expected result isn't clear. Please share a dummy sample and the desired result.

 

 

Best Regards,

  • 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