Forum Discussion

LousQuinn's avatar
LousQuinn
Copper Contributor
Aug 18, 2023

Transposing data to set columns

Hello, I'm trying to find a way of achieiving the following -   Data that I import into excel is presented in the following way, the headings will stay the same. The rows of data will conti...
excel
Formulas and Functions
LousQuinn's avatar
LousQuinn
Copper Contributor
Aug 20, 2023

Hi mathetes 

 

thanks for the response.

 

I’m currently building a MVP and the excel widget which I use, Uses the headings to import the data. 

So if the spreadsheet was set up with the names and emails et cetera in one column I would only be able to bring in one at a time and I’d like to bring in 30.

 

thanks,

Lou

 

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 20, 2023

LousQuinn I hope I understood your requirement correctly. The attached file contains an example of a Power query solution (noting fancy).

 

 

  • LousQuinn's avatar
    LousQuinn
    Copper Contributor
    Aug 21, 2023

    Hi Riny_van_Eekelen thanks for this, it's nearly what I need.

     

    From sheet 1, the data that is imported after 30 needs to drop below as per second image

     

    and continue that sequence, so when data is imported, it will be consistently split and allocated under the set headings. If Sheet 1 had 90 rows of data, in Table 1 it it would be split over 3 rows.

    Thanks,

    Lou

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Aug 21, 2023

      LousQuinn Again, nothing fancy, and it can probably be done neater. The modifications I made took perhaps three minutes to make and gives you a step-by-step approach by adding columns with nested tables and then keeping only the last one for expansion.

       

Resources