Fala galera!!
Beleza?
Aqui é o Fábio Gatti.
Nesse vídeo demonstro como tratar uma tabela com repetições de cabeçalhos, PORÉM com cabeçalhos com dados ÚTEIS (datas na horizontal)
E aí... resolveria diferente?
Aqui a fonte para você praticar:
(Só colar em uma Consulta Nula no Power Query)
let
Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lVfLbiQ3DPwVw+dGIvEl6dgZ9zqd2O7FzKxzWOwh9wC55CfyXfmxUCTlyJt9AgNb7OlWU8Viseb9+9vz9va8XX64XW5PD/v2dN109bhd9O/1z79+/0P/p/yjfiBBigDmAOeA5oDnQOagzEGdgzYFOc3BnEGODD4s72+Py2k99+yPpzfbfl3P+6qRfpiQs/4H4rJU0lVJJEsWXUmtZSl9VYTTUkBXGXL2a7nltKT+BFZd2bOA0JaqC2olLxlsO33AvsRS2R9lKGVBeZXZevd83K93x+VmvVyO096XniIVLGS7llxxIXtRSbpD359yrX0vTSg1XvoCEXhJ/YHMQovfhbA0y6dSss0gYfW7MCVZmp24pLqAJcv6qmoZ/nJc/vlbLx1v9tP+tN7cbTePx3VkpzdKcRyIKsWqNvR9Og5s70UFWCwp0JW9LheO1wGW5tcq56VfyaSnYbsLqfm2koAW8pQJ+3l6fnfrw/P6Oj+F9DwS5FSbltbe3KR6VSDRS0FHNnr45JhypWJIcgfXYANSAK14pNXzL0nEd1MMmkNJvVSWYeHUoZ8T9CbS7llPx3a5OR2P21kLvY9EK0H2RItUMBSEAP0dLCh2qSnchgs3EKskNr3JAIJU0I+FSb/0fBOAf1uqElAcvhJHLcVrNud5Pa9Pl7fH+boFlvfrSFH5jb6FZN3MKkugdLPNkErUrGQsXlmWGugTM/izVBUvsINifAmV0dtE68VREMDspwHAFGzcntenu/PxqV7GKrqdV7XoocU7MjDNqHx38mTkvn1TRO09aP2j4DnoqDdY1zBpY9h+UryvAZSVwUC9xN7D+/m3/Umv7Y/H8/ZSTs76tAOPHGWBTODdCiWzI5QToGUhOboWKfpXixMNz61FPbVihj9rqa09iLLfo8yEXog5pSDZ0Su5PWzX8/G0n156l0jb04XCsKfUlcZYppuaCGIRcCIWz6li87qLsBcRuso415qu7EvMqoR2ZFKkfKuhnT2/h3en/aOmnUSFSsJgEiHFwXPqB/UX6kZOkSwYIqZH8PsgK7n9GuTmT0hVtF3UBUKZhXRnw7LWsYmi2rPuGf66PRuCn5EVKtpYflbosmxIaClSbI6IXmhhGd2ZdYo4Yg1CMEAk0smswOZoqDR0lMgoWSQPSW/c694zvKyP77aHbxCWjDKaCzonHa9kFE8Usgx5yJnythn/JUnwX8nqiXCB6p1QZcydPvSMycIDb+U+j1J/h3fIt5N3GAHOAc0Bz4HMQZmDOgdtCtw7jGDOIEcGPf/7h/XdT9v5s2RF7JiIVZhqUIq0xH6NRLXLqNxydTS56sp1cgxFYu0Sq69S1S81nT0Skzo5eQu7QulroL+np3dSv7B3Pfy8g2DdnV0jEIp4sSiXwTekcAKq1TG3oXe3XWPtrDgdK+NdDondkeSWxpkavRyYh51AHWPwjTZHuHE0hUiNKZpbC9HW6THmNHYN7gvIka2QuGsopUUr/mfKiFryzEI6iVQqbCvG1Ifq67ny6SqrtqawKEruMvSiDuRUk1wNMqUwfBlT2A01Hj6qFbeQSjU1ASZRb3wfeBITQyhhDGhUp8IDxMf1Ix6+kqSWIQyr9DO7U2zVR5eoe3IYJINXT2dzzCDsCYZbcK3NZUy+mJ/US+EiIi35WXXgdrRd0PfLzWU73+/HFzKElCG8H2vJXOFf+MJZQlLr4GZOw1BBGeZPVdYJoIKafYL3UevWTU2AOzbqc9GKRJzDPCh8X2kVda41qjFcetf6Fu4Z0theDU60FGUK4eSUgg7U7/O+IPQ0pGdto7G2NsaA9oyztZvKsGHfoZcw6+UIcA5oDngOZA7KHNQ5aFPgejmCOYMcGfT81wdVy+tXFKl0f+pyQRKGAjs53BKJDrnmbSJRWW3acK/a0KPJMcV9BVSRHHB1c9EEatrdqaMaZNdbG/Vhd5WgL6l+0SeRmtMXNaRw01whLIUay2CmyiyFE0haZCOKsrv6CYBKmGdQzoQBVo45qXUmGOlo3M1gPfCdlMCZEiPAOaA54DmQEXz8sZ+B29P+xsbg9Vgfft52E0vrCWnxKwkb8bBoGJ4K+vndRHS19aZuzeuB+rvb5eV/r/zwLw==", BinaryEncoding.Base64), Compression.Deflate)))
in
Fonte
Me acompanhem nas redes sociais:
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Valeu!!
Ещё видео!