Dear All
I have following issue in Excel Office 365. From the database my company is using we receive the following table (Here is a dummy as the Database output is not ready yet):
See first sheet (Input)
From This Table I want to create labels which will look like seen here:
See sheet Result.
So what I want to do take the info from every even row until row x in the first sheet and transfer the information to the label so it can be filled in the results sheets in as seen above. I found a solution how to seperate every secon row as seen here I used the Offset function in a separate sheet which will be hidden later:
See sheet Conversion_1 (e.g. =OFFSET((Input!$A$2);(ROW()-2)*2;0))
The issue is now if I now try to fill in the Result page with all the info combined it is always incrementing the results by 4 rows.
Now is there a function to take the table from the last picture and make another table automatically where between each data row are four blank rows?
The QR-Codes which I use I create so far with Google Sheets as it has a function built in to create it, meaning i will just copy the Codes from the sheet and adjust them in size. Is there a similar function from base Excel?
Thank you for your help, this is my first post here so If I made mistakes or did not describe the issue good enough please tell me.
Bookmarks