ericcartman
New Member
- Joined
- Aug 2, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Hello guys, and thanks in advance if someone is willing to help me with this issue.
I have excel file for generating invoices. Now I need 2D barcode. I decided to buy Tbarcode plugin. But for that plugin to work, all data needs to be in one cell (16 lines, divides with newline)
I am sending screenshot. Maybe there is an easier way to do it with PowerQuery? I googled for a few hours and didn't find anything useful for my example
So this are my problems:
- in barcode field (on the right) text is without newline so barcode cannot be generated with needed values - so I need it exactly as in cell B2 in separate lines
- cell B2: Lines in blue needs to be transfered from 4 different cells into this one large for barcode generator. Is is irrelevant which ones so I called them B11-B14 now, and lines colored green are fixed values.
I have excel file for generating invoices. Now I need 2D barcode. I decided to buy Tbarcode plugin. But for that plugin to work, all data needs to be in one cell (16 lines, divides with newline)
I am sending screenshot. Maybe there is an easier way to do it with PowerQuery? I googled for a few hours and didn't find anything useful for my example
So this are my problems:
- in barcode field (on the right) text is without newline so barcode cannot be generated with needed values - so I need it exactly as in cell B2 in separate lines
- cell B2: Lines in blue needs to be transfered from 4 different cells into this one large for barcode generator. Is is irrelevant which ones so I called them B11-B14 now, and lines colored green are fixed values.