Home

Request for help with complex transposing

gijs van Bergen
Occasional Contributor

Hello there!

 

I can really need some help. In the picture down below you can see that I have 8 articles with each a certain time in every step. As an outcome I am seeking to get the table below in the picture. The article name should be duplicated for every step and in that step the time should be stated. So for example article 100 has 4 steps, so it should be duplicated 4 times and for each step the amount of time will stated in the column to the right. I need this in formula so I can use it in further updates as well.

1 Reply

Hi,

 

Try the attached. I did this with formulas, as you wanted, but it does mean that each block of formulas (Green & Orange) is different to the next.  This means they can't just be dragged down so, I added steps to 20 and articles down to 11.  Hope that helps.

 

Kind regards

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies