Forum Discussion
Solved
Conditional import from txt or csv to Excel
Hello, so, I need to import data from a .txt file (might as well be a .csv) that contains: "Initial date", "Final date", "Group". In my Excel sheet I have empty date cells that must that must be wri...
- Sounds like Power Query works:
(1) Goto Tab Data->Get Data->From File->From Text/CSV
(2) Select source file t-> "Transform Data" -> PowerQuery Editor
(3) Transform the data, e.g. "Use First Row as Headers" -> Add "Conditional Column"
(4) Edit condition, Filter By Contional Value, Apply & Close
Sounds like Power Query works:
(1) Goto Tab Data->Get Data->From File->From Text/CSV
(2) Select source file t-> "Transform Data" -> PowerQuery Editor
(3) Transform the data, e.g. "Use First Row as Headers" -> Add "Conditional Column"
(4) Edit condition, Filter By Contional Value, Apply & Close
(1) Goto Tab Data->Get Data->From File->From Text/CSV
(2) Select source file t-> "Transform Data" -> PowerQuery Editor
(3) Transform the data, e.g. "Use First Row as Headers" -> Add "Conditional Column"
(4) Edit condition, Filter By Contional Value, Apply & Close