Forum Discussion
Convert Text to Cell
Please checked attached in next sheet. I queried sample table in first sheet without manually added columns.
Yes, that's just an idea. If you share in which exactly form and format you'd like to have the result it'll be easy with concrete suggestion.
hi
thank you Guys so much, for all you help.
i upload a manually edited version.
- column A to G is how i get i from my CSV import
- i then manually add for testing the column H, I, J
- after it i copied for testing the stuff by hand from column E to H, I, J
Line 2 and 3 are a result what would makes me already happy 🙂
Line 4 and 5 are the ultimate "i can go to weekend and relax" version
Please checked attached in next sheet. I queried sample table in first sheet without manually added columns.
was running the Query on 1 of my files with 5k entry's - very nice
but i think there is still a small problem.or maybe 2 🙂
the source files have UTC time-zone, i think in this way also the US-Dateforma. but witht eh query we just "format" this new
see PrintScreen. so, it should be the 4. August 2022 and with he Query we make out if this 8. April
or I'm wrong?
i also have approx 529 errors... maybe connected to the same problem above
I see, datetime is in US locale, with sample 8/8/2022 it was hard to understand. To convert from specific locale select column(s), right click, Change type->Using locale
and use here English US
or simply add culture in formula bar
- Holy Cow 🙂
thanks for it... was now clicking in PowerQuery - as this tool is compl. new for me.
i think with this PQ i can now solve my Problem
great