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