can i please get a little help. I would like to get multiple data with header (wich should be taged »name + 1,2,3,etc…)in one row based on an ID wich is »Series« and then sorted on »Name of component batch« and its matching »component of batch«
Guess this is only doable in VBA
I made a yellow spreadsheet of current state (this is the form in wich i get data), and blue spreadsheet desired look (this is how i would like it to look with macro).
Thank you in advance