I have an excel file of 700 rows . I would like to create a "key" column by concatenating "Employee number plus date" in Power query.
Input file
=======
"Emp Number....... Date1......... Date 2 ......... Date 3..... Date n"
========================================
" 1234.................. 01/01/2015....04/23/2015...09/23/2015 "
Output File
=======
"Key ............................ Emp Number......Date1...............Date 2....... Date 3..... Date n"
======================================================
123401/01/2015........... 1234............... 01/01/2015.......04/23/2015... 09/23/2015 "
123404/23/2015........... 1234 ........... 01/01/2015..... 04/23/2015 ..... 09/23/2015 "
123404/23/2015........... 1234 ........... 01/01/2015.... 04/23/2015 ...... 09/23/2015 "
Input file
=======
"Emp Number....... Date1......... Date 2 ......... Date 3..... Date n"
========================================
" 1234.................. 01/01/2015....04/23/2015...09/23/2015 "
Output File
=======
"Key ............................ Emp Number......Date1...............Date 2....... Date 3..... Date n"
======================================================
123401/01/2015........... 1234............... 01/01/2015.......04/23/2015... 09/23/2015 "
123404/23/2015........... 1234 ........... 01/01/2015..... 04/23/2015 ..... 09/23/2015 "
123404/23/2015........... 1234 ........... 01/01/2015.... 04/23/2015 ...... 09/23/2015 "