WOW! Tough challenge and I like the formula solution. I'm eager to see the Power Query solution!
@MySpreadsheetLab
6 жыл бұрын
Hopefully I'll get it done today :)
@MySpreadsheetLab
6 жыл бұрын
Excel On Fire im done! 00180 Power Query video 😎
@ExceliAdam
6 жыл бұрын
A really tough case of data distribution and the solution is simpler than it might seem
@MySpreadsheetLab
6 жыл бұрын
Exactly! As long as there is a consistent pattern and some creativity there's a solution. Thanks for watching Adam.
@kowsergazi
5 жыл бұрын
I'm new on your channel. Thanks for such a nice video. Your channel also added to my favorites. Keep it up....
@MySpreadsheetLab
5 жыл бұрын
Thanks for subscribing Kowser! I also have a blog: Www.myspreadsheetlab.com/blog
@barttitulaerexcelbart9400
6 жыл бұрын
Thanks Kevin. Would it be possible to find the cell address for a name and then look above to find the nearest empty cell. The manager is then one below... greetings Bart
@MySpreadsheetLab
6 жыл бұрын
I think vba could do that. Nice idea Bart ! Thanks for watching
@vudien2517
6 жыл бұрын
Could you use offset to find 1st bank cell then upp 01 row to find manager?
@MySpreadsheetLab
6 жыл бұрын
VU DIEN interesting idea! I will try this tomorrow. Thanks for watching.
@vudien2517
6 жыл бұрын
Pls adjust range of manager size is not same.Each range just seperate 1 blank row. Could you use power query to get manager list so that we find column number?
@MySpreadsheetLab
6 жыл бұрын
Here i've included a couple of Power Query solutions: www.myspreadsheetlab.com/normalize-data-using-excel-get-transform/
@MySpreadsheetLab
6 жыл бұрын
Thanks for the idea Vu! I added a solution based on your idea! Thanks! www.myspreadsheetlab.com/data-disaster-non-normalized-data-in-excel/
@entertainmentgalaxy971
6 жыл бұрын
any Power query solution?
@MySpreadsheetLab
6 жыл бұрын
Definitely! That will be my next video! Thanks for watching Haider Ali !
@entertainmentgalaxy971
6 жыл бұрын
anxiously waiting.. keep sharing. Thanks for sharing.....
@MySpreadsheetLab
6 жыл бұрын
Haider Ali I've uploaded 00180 my Power Query solution 😃
Пікірлер: 19