Forum Discussion
Excel text to colum
Hi, I have several names and emails on one colum and I am wondering how I can trasfer that into an organized list, name, email and phone number? If possible? Thank you so much for your time! I have screenshots for your review, I am so sorry, I am very new to this and I am catching up.
You can try Power Query, The blue table is a dynamic table. You can enter as many names, email addresses and phone numbers (in this order) as required. Then click in any cell of the green table and right-click with the mouse. Then select refresh.
OliverScheurich It was a bit of a struggle for me following the German language names in Power Query! Saw some Index columns a calculation Modulo 3 though. I agree with the use of an Excel Table for any dataset that is changing.
If the OP happens to have a fully updated version of Excel 365 and the source data forms an absolutely regular pattern one could use
= WRAPROWS(Tabelle1[Spalte1],3)I
