Hi thebrucekt,
Because you have Excel 2016 you can use Power Query to convert your data. See sheet 3 where I did a little PQ on it. Click on the data tab and view query. See if this will work for you.
Attached deleted as per OP request.
Hi thebrucekt,
Because you have Excel 2016 you can use Power Query to convert your data. See sheet 3 where I did a little PQ on it. Click on the data tab and view query. See if this will work for you.
Attached deleted as per OP request.
Last edited by MarvinP; 11-07-2017 at 09:16 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks