SHARE
TWEET

Untitled

a guest Jul 18th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Date          Header1           Header2      
  2. 01/01/2016  value_header1_1    value_header2_1
  3. 02/01/2016  value_header1_2    value_header2_2
  4. 03/01/2016  value_header1_3    value_header2_3
  5. 04/01/2016  value_header1_4    value_header2_4
  6. 05/01/2016  value_header1_5    value_header2_5
  7.      
  8. Date          Header1         Extra column      
  9. 01/01/2016  value_header1_1   header1    
  10. 02/01/2016  value_header1_2   header1
  11. 03/01/2016  value_header1_3   header1
  12. 04/01/2016  value_header1_4   header1
  13. 05/01/2016  value_header1_5   header1
  14. 01/01/2016  value_header2_1   header2
  15. 02/01/2016  value_header2_2   header2
  16. 03/01/2016  value_header2_3   header2
  17. 04/01/2016  value_header2_4   header2
  18. 05/01/2016  value_header2_5   header2
  19.      
  20. =transpose(split(join(";",'Daily data'!B1:B,'Daily data'!C1:C),";"))
  21.      
  22. ={filter({A2:A, B2:B, iferror(A2:A/0, "header1")}, len(A2:A)); filter({A2:A, C2:C, iferror(A2:A/0, "header2")}, len(A2:A))}
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top