Aug-16-2019, 03:52 PM
My input data is as below:
I still want to keep all the columns.
Caegory Model TM Date WAT Actual Date Standard Cal N22HN 2019-07-07 7 Fail 2019-08-01 Noraml 5/9 2019-07-22 12 1.36 2019-08-02 Struck 2/1.3 2019-07-30 62/9 6/1 2019-08-03 Miss 4TM--> "=HYPERLINK("#Sheet2!A1","TM")"
I still want to keep all the columns.