format table

[Steph66]

Hello,

I receive a file with hourly data for 1 year with each 10min value in table. I would like to reorganise that in one column (Feuil1) . I have trying to use concat value but not works have you an idea to make that easly ?

exemple data.xlsx

[Glenn Kennedy]

Delete ALL expected results. No copy/paste needed.

=HSTACK(Feuil0!$A$1+SEQUENCE(120,,0,10)/(24*60),TOCOL(Feuil0!C1:H24))

[Steph66]

with concat on the feuil1, I arrive to "build" the good formula and copy past only the value in new cell but I need to click enter on each cell to display the result, and i have more than 50 000row to validate...

[Steph66]

Delete ALL expected results. No copy/paste needed.

=HSTACK(Feuil0!$A$1+SEQUENCE(120,,0,10)/(24*60),TOCOL(Feuil0!C1:H24))

I don't understand but thank a lot

[Glenn Kennedy]

You're welcome. Thanks for letting us know that you got an answer.

---

If that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.